package cn.edu.zhku.citrusmonitor.announcement.dao;

import java.sql.SQLException;
import java.util.List;

import cn.edu.zhku.citrusmonitor.domain.TbAnnouncement;

public interface AnnouncementDao {

	public int addAnnounce(TbAnnouncement announce) throws SQLException;

	public int removeAnnounce(String question_id) throws SQLException;

	public int modifyAnnounce(TbAnnouncement announce) throws SQLException;

	public List<TbAnnouncement> findAnByWord(String content) throws SQLException;

	int count(String content) throws SQLException;

	public List<TbAnnouncement> showAnnounce(int pageSize) throws SQLException;

	public TbAnnouncement showAnById(String announcementId) throws SQLException;

	public List<TbAnnouncement> showAll(int currentPage, int pageSize) throws SQLException;

	public int delAll(String[] ids) throws SQLException;

}
